Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2985
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	303.3 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Warnings

`gross_revenue` is highly correlated with `qtde_invoices` and 1 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`qtde_products` is highly correlated with `qtde_invoices`	High correlation
`avg_ticket` is highly correlated with `qtde_returns` and 1 other fields	High correlation
`qtde_returns` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 3 other fields	High correlation
`recency_days` is highly correlated with `qtde_invoices`	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `avg_unique_basket_size`	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qtde_products` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 2 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `qtde_items`	High correlation
`avg_unique_basket_size` is highly correlated with `qtde_products`	High correlation
`gross_revenue` is highly correlated with `avg_ticket` and 5 other fields	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_returns` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qtde_products`	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.71859111)	Skewed
`qtde_returns` is highly skewed (γ1 = 51.85337872)	Skewed
`avg_basket_size` is highly skewed (γ1 = 45.92326414)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`qtde_returns` has 1453 (48.7%) zeros	Zeros

Reproduction

Analysis started	2021-06-13 18:45:24.866468
Analysis finished	2021-06-13 18:46:04.471824
Duration	39.61 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2985
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2375.015075

Minimum	0
Maximum	5896
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	0
5-th percentile	186.2
Q1	947
median	2163
Q3	3617
95-th percentile	5207.2
Maximum	5896
Range	5896
Interquartile range (IQR)	2670

Descriptive statistics

Standard deviation	1604.366167
Coefficient of variation (CV)	0.6755183087
Kurtosis	-0.9931192818
Mean	2375.015075
Median Absolute Deviation (MAD)	1302
Skewness	0.3594335959
Sum	7089420
Variance	2573990.798
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
2702	1	< 0.1%
641	1	< 0.1%
5236	1	< 0.1%
5058	1	< 0.1%
2694	1	< 0.1%
647	1	< 0.1%
2696	1	< 0.1%
649	1	< 0.1%
651	1	< 0.1%
Other values (2975)	2975	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5896	1	< 0.1%
5877	1	< 0.1%
5867	1	< 0.1%
5861	1	< 0.1%
5840	1	< 0.1%
5836	1	< 0.1%
5830	1	< 0.1%
5819	1	< 0.1%
5818	1	< 0.1%
5808	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2985
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.2201

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	12347
5-th percentile	12615.2
Q1	13792
median	15223
Q3	16771
95-th percentile	17964.8
Maximum	18287
Range	5940
Interquartile range (IQR)	2979

Descriptive statistics

Standard deviation	1721.133195
Coefficient of variation (CV)	0.1127117477
Kurtosis	-1.208464419
Mean	15270.2201
Median Absolute Deviation (MAD)	1490
Skewness	0.02916556856
Sum	45581607
Variance	2962299.476
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16384	1	< 0.1%
12987	1	< 0.1%
14984	1	< 0.1%
17033	1	< 0.1%
13704	1	< 0.1%
12939	1	< 0.1%
17037	1	< 0.1%
14125	1	< 0.1%
13363	1	< 0.1%
18164	1	< 0.1%
Other values (2975)	2975	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2979
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2782.437548

Minimum	6.2
Maximum	280206.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.62
Q1	573.22
median	1098.43
Q3	2330.92
95-th percentile	7320.916
Maximum	280206.02
Range	280199.82
Interquartile range (IQR)	1757.7

Descriptive statistics

Standard deviation	10635.51096
Coefficient of variation (CV)	3.822371853
Kurtosis	348.5532904
Mean	2782.437548
Median Absolute Deviation (MAD)	682.35
Skewness	16.62512019
Sum	8305576.08
Variance	113114093.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63	2	0.1%
734.94	2	0.1%
379.65	2	0.1%
745.06	2	0.1%
331	2	0.1%
731.9	2	0.1%
26879.04	1	< 0.1%
284.46	1	< 0.1%
610.52	1	< 0.1%
605.12	1	< 0.1%
Other values (2969)	2969	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
6.9	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
63	2	0.1%

Value	Count	Frequency (%)
280206.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
143825.06	1	< 0.1%
124914.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
81024.84	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	272
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.47303183

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	32
Q3	82
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	71

Descriptive statistics

Standard deviation	77.76614786
Coefficient of variation (CV)	1.206181029
Kurtosis	2.750197
Mean	64.47303183
Median Absolute Deviation (MAD)	26
Skewness	1.790720645
Sum	192452
Variance	6047.573753
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.8%
2	85	2.8%
8	76	2.5%
10	67	2.2%
9	67	2.2%
7	66	2.2%
17	64	2.1%
22	55	1.8%
Other values (262)	2234	74.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.8%
3	85	2.8%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.5%
9	67	2.2%
10	67	2.2%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	3	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtde_invoices
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	59
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.734338358

Minimum	1
Maximum	209
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	209
Range	208
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.90180138
Coefficient of variation (CV)	1.552367653
Kurtosis	194.6807795
Mean	5.734338358
Median Absolute Deviation (MAD)	2
Skewness	10.86872714
Sum	17117
Variance	79.2420678
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	788	26.4%
3	505	16.9%
4	385	12.9%
5	242	8.1%
1	193	6.5%
6	172	5.8%
7	143	4.8%
8	98	3.3%
9	68	2.3%
10	54	1.8%
Other values (49)	337	11.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	193	6.5%
2	788	26.4%
3	505	16.9%
4	385	12.9%
5	242	8.1%
6	172	5.8%
7	143	4.8%
8	98	3.3%
9	68	2.3%
10	54	1.8%

Value	Count	Frequency (%)
209	1	< 0.1%
201	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
93	1	< 0.1%
91	1	< 0.1%
86	1	< 0.1%
73	1	< 0.1%
63	1	< 0.1%
62	1	< 0.1%

qtde_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1677
Distinct (%)	56.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1605.125963

Minimum	1
Maximum	196915
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	1
5-th percentile	101
Q1	294
median	634
Q3	1398
95-th percentile	4406.4
Maximum	196915
Range	196914
Interquartile range (IQR)	1104

Descriptive statistics

Standard deviation	5878.60124
Coefficient of variation (CV)	3.66239247
Kurtosis	467.002295
Mean	1605.125963
Median Absolute Deviation (MAD)	418
Skewness	17.8666028
Sum	4791301
Variance	34557952.54
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
88	11	0.4%
310	10	0.3%
300	10	0.3%
150	9	0.3%
84	8	0.3%
272	8	0.3%
394	8	0.3%
246	7	0.2%
264	7	0.2%
152	7	0.2%
Other values (1667)	2900	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
3	1	< 0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%

Value	Count	Frequency (%)
196915	1	< 0.1%
80997	1	< 0.1%
80265	1	< 0.1%
77374	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%

qtde_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	460
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.6338358

Minimum	1
Maximum	7847
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	66
Q3	135
95-th percentile	382
Maximum	7847
Range	7846
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.7042745
Coefficient of variation (CV)	2.199264768
Kurtosis	356.0012832
Mean	122.6338358
Median Absolute Deviation (MAD)	44
Skewness	15.73037818
Sum	366062
Variance	72740.3957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	42	1.4%
29	38	1.3%
19	38	1.3%
35	38	1.3%
20	36	1.2%
11	32	1.1%
15	31	1.0%
31	31	1.0%
26	30	1.0%
27	30	1.0%
Other values (450)	2639	88.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	18	0.6%
4	16	0.5%
5	28	0.9%
6	26	0.9%
7	18	0.6%
8	22	0.7%
9	27	0.9%
10	25	0.8%

Value	Count	Frequency (%)
7847	1	< 0.1%
5675	1	< 0.1%
5111	1	< 0.1%
4595	1	< 0.1%
2700	1	< 0.1%
2379	1	< 0.1%
2076	1	< 0.1%
1818	1	< 0.1%
1677	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2984
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.74349696

Minimum	2.150588235
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.919743966
Q1	13.1605
median	18.18108696
Q3	25.31482759
95-th percentile	90.72201312
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	12.15432759

Descriptive statistics

Standard deviation	1033.269312
Coefficient of variation (CV)	19.96906612
Kurtosis	2916.221951
Mean	51.74349696
Median Absolute Deviation (MAD)	6.130240562
Skewness	53.71859111
Sum	154454.3384
Variance	1067645.471
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.83333333	2	0.1%
17.49275862	1	< 0.1%
9.418292683	1	< 0.1%
5.01173913	1	< 0.1%
18.82290698	1	< 0.1%
28.89968794	1	< 0.1%
46.07413043	1	< 0.1%
25.77538462	1	< 0.1%
8.745172414	1	< 0.1%
18.15061538	1	< 0.1%
Other values (2974)	2974	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.504876033	1	< 0.1%
2.50837156	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.771005291	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
2027.86	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
931.5	1	< 0.1%
872.13	1	< 0.1%
835.864	1	< 0.1%
643.8585714	1	< 0.1%
640	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1255
Distinct (%)	42.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66.90582076

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	1
5-th percentile	7.407171717
Q1	25.28571429
median	47.66666667
Q3	85
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.71428571

Descriptive statistics

Standard deviation	63.47649879
Coefficient of variation (CV)	0.9487440416
Kurtosis	4.941588072
Mean	66.90582076
Median Absolute Deviation (MAD)	26.12121212
Skewness	2.073697691
Sum	199713.875
Variance	4029.265899
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	24	0.8%
4	23	0.8%
70	22	0.7%
7	20	0.7%
1	19	0.6%
35	19	0.6%
21	18	0.6%
11	18	0.6%
46	18	0.6%
49	18	0.6%
Other values (1245)	2786	93.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	19	0.6%
1.5	1	< 0.1%
2	14	0.5%
2.5	1	< 0.1%
2.565517241	1	< 0.1%
3	15	0.5%
3.271929825	1	< 0.1%
3.321428571	1	< 0.1%
3.5	2	0.1%
4	23	0.8%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1355
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06544749662

Minimum	0.005449591281
Maximum	4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.009529875645
Q1	0.01792114695
median	0.0297029703
Q3	0.05660377358
95-th percentile	0.2222222222
Maximum	4
Range	3.994550409
Interquartile range (IQR)	0.03868262663

Descriptive statistics

Standard deviation	0.1464278785
Coefficient of variation (CV)	2.237333528
Kurtosis	207.4452392
Mean	0.06544749662
Median Absolute Deviation (MAD)	0.01466537631
Skewness	10.83265063
Sum	195.3607774
Variance	0.02144112361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02777777778	21	0.7%
0.1666666667	21	0.7%
0.3333333333	20	0.7%
0.09090909091	18	0.6%
1	17	0.6%
0.4	17	0.6%
0.0625	16	0.5%
0.02380952381	16	0.5%
0.03571428571	15	0.5%
0.1333333333	15	0.5%
Other values (1345)	2809	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
4	1	< 0.1%
2	1	< 0.1%
1.571428571	1	< 0.1%
1.5	3	0.1%
1	17	0.6%
0.8333333333	1	< 0.1%
0.75	1	< 0.1%
0.6666666667	13	0.4%
0.6648793566	1	< 0.1%
0.6	1	< 0.1%

qtde_returns
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	217
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.24020101

Minimum	0
Maximum	80995
Zeros	1453
Zeros (%)	48.7%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	103.8
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1509.254596
Coefficient of variation (CV)	23.86543009
Kurtosis	2774.251512
Mean	63.24020101
Median Absolute Deviation (MAD)	1
Skewness	51.85337872
Sum	188772
Variance	2277849.436
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1453	48.7%
1	183	6.1%
2	153	5.1%
3	107	3.6%
4	90	3.0%
6	72	2.4%
5	64	2.1%
8	49	1.6%
12	48	1.6%
7	47	1.6%
Other values (207)	719	24.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1453	48.7%
1	183	6.1%
2	153	5.1%
3	107	3.6%
4	90	3.0%
5	64	2.1%
6	72	2.4%
7	47	1.6%
8	49	1.6%
9	38	1.3%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8060	1	< 0.1%
4627	1	< 0.1%
3768	1	< 0.1%
3335	1	< 0.1%
2975	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1920	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1983
Distinct (%)	66.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	246.3714787

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103
median	172
Q3	281
95-th percentile	598.64
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178

Descriptive statistics

Standard deviation	782.4497016
Coefficient of variation (CV)	3.175894003
Kurtosis	2350.161191
Mean	246.3714787
Median Absolute Deviation (MAD)	82.5
Skewness	45.92326414
Sum	735418.8639
Variance	612227.5356
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
82	10	0.3%
114	10	0.3%
60	9	0.3%
136	9	0.3%
73	8	0.3%
86	8	0.3%
150	7	0.2%
64	7	0.2%
130	7	0.2%
Other values (1973)	2899	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.1%
1.5	1	< 0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
3684.47619	1	< 0.1%
2880	1	< 0.1%
2697.465753	1	< 0.1%
2183.2	1	< 0.1%
2160.333333	1	< 0.1%
2141.5	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1015
Distinct (%)	34.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.02564613

Minimum	1
Maximum	300.6470588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3.478947368
Q1	10
median	17.22222222
Q3	27.71428571
95-th percentile	56.71515152
Maximum	300.6470588
Range	299.6470588
Interquartile range (IQR)	17.71428571

Descriptive statistics

Standard deviation	18.94048787
Coefficient of variation (CV)	0.8599288192
Kurtosis	23.48302059
Mean	22.02564613
Median Absolute Deviation (MAD)	8.222222222
Skewness	3.169981848
Sum	65746.55369
Variance	358.7420806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	54	1.8%
14	44	1.5%
11	35	1.2%
1	33	1.1%
9	32	1.1%
20	31	1.0%
17	29	1.0%
10	29	1.0%
6	28	0.9%
15	28	0.9%
Other values (1005)	2642	88.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	33	1.1%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	9	0.3%
1.555555556	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
1.9	1	< 0.1%

Value	Count	Frequency (%)
300.6470588	1	< 0.1%
203.5	1	< 0.1%
149	1	< 0.1%
145.3333333	1	< 0.1%
136.25	1	< 0.1%
135.75	1	< 0.1%
127	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%
114	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	18.152222	35.500000	0.486111	40.0	50.970588	8.735294
1	1	13047	3237.54	31.0	10.0	1391.0	172.0	18.822907	26.307692	0.052478	36.0	139.100000	17.200000
2	2	12583	7281.38	2.0	15.0	5060.0	247.0	29.479271	21.823529	0.048387	51.0	337.333333	16.466667
3	3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	92.666667	0.017921	0.0	87.800000	5.600000
4	4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	8.600000	0.136364	22.0	26.666667	1.000000
5	5	15291	4668.30	25.0	15.0	2103.0	103.0	45.323301	21.750000	0.057307	29.0	140.200000	6.866667
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	18.300000	0.073569	399.0	172.428571	15.571429
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	88.719836	32.454545	0.041899	42.0	171.416667	5.083333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	4.144444	0.315508	474.0	419.714286	26.142857
9	9	14527	8508.82	2.0	55.0	2089.0	972.0	8.753930	5.888889	0.231183	40.0	37.981818	17.672727

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
2975	5808	17727	1060.25	15.0	1.0	645.0	66.0	16.064394	6.0	0.285714	6.0	645.000000	66.000000
2976	5818	17232	421.52	2.0	2.0	203.0	36.0	11.708889	12.0	0.153846	0.0	101.500000	18.000000
2977	5819	17468	137.00	10.0	2.0	116.0	5.0	27.400000	4.0	0.400000	0.0	58.000000	2.500000
2978	5830	13596	697.04	5.0	2.0	406.0	166.0	4.199036	7.0	0.250000	0.0	203.000000	83.000000
2979	5836	14893	1237.85	9.0	2.0	799.0	73.0	16.956849	2.0	0.666667	0.0	399.500000	36.500000
2980	5840	12479	527.20	11.0	1.0	385.0	31.0	17.006452	4.0	0.333333	34.0	385.000000	31.000000
2981	5861	14126	706.13	7.0	3.0	508.0	15.0	47.075333	3.0	1.000000	50.0	169.333333	5.000000
2982	5867	13521	1093.65	1.0	3.0	736.0	436.0	2.508372	4.5	0.300000	0.0	245.333333	145.333333
2983	5877	15060	303.09	8.0	4.0	263.0	121.0	2.504876	1.0	2.000000	0.0	65.750000	30.250000
2984	5896	12558	269.96	7.0	1.0	196.0	11.0	24.541818	6.0	0.285714	196.0	196.000000	11.000000

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows